adunstan

with recursive
dag (depended_on,dependent) as
  (
      values
      ('b2'::text,'d1'::text),
      ('d1','d2'),
      ('d2','d3'),
      ('d3','d4'),
      ('b1','a1'),
      ('b2','a1'),

adunstan

#!/bin/sh
set -e

# Based on nealmcb's + ErebusBat's script from http://serverfault.com/questions/211425/

# put this file in etckeeeper's commit.d directory
# in the config file set MIRROR_ROOT (somewhere under /etc) MIRROR_FILES and MIRROR_DIRS
# the latter two can contain wildcards
# all three symbols must be exported or they won't be seen by this script

adunstan

@echo off
rem see http://stackoverflow.com/questions/9946322/how-to-generate-an-import-library-lib-file-from-a-dll#9946390

rem see also http://www.postgresql-archive.org/MSVC-pl-perl-error-message-is-not-verbose-enough-td5913411.html
rem see also  https://postgr.es/m/CABcP5fjEjgOsh097cWnQrsK9yCswo4DZxp-V47DKCH-MxY9Gig@mail.gmail.com


REM Usage: dll2lib [32|64] some-file.dll
REM
REM Generates some-file.lib from some-file.dll, making an intermediate

adunstan

#  appveyor.yml
install:
  - cinst winflexbison
  - '"C:\Program Files\Microsoft SDKs\Windows\v7.1\Bin\SetEnv.cmd" /x64'
  
before_build:
  - net user testuser Blurfl9426! /add
  - rename c:\ProgramData\chocolatey\bin\win_flex.exe flex.exe
  - rename c:\ProgramData\chocolatey\bin\win_bison.exe bison.exe
  - curl -S -O https://gist.githubusercontent.com/adunstan/7f18e5db33bb2d73f69ff8c9337a4e6c/raw/buildsetup.pl

adunstan

#  appveyor.yml
  
before_build:
  - set PATH=C:\Program Files\PostgreSQL\9.6\bin;%PATH%
  - cmake -G "Visual Studio 14 2015 Win64"
  - dir
  - pg_config
  
build:
  project: cranges.sln

adunstan

perl -p -e "local \$/ = undef; my \$log = <>; \$log =~ s/('|\\\$[a-zA-Z0-9_]*\\\$)(.*)\$1/\$1 . (q[X] x length(\$2)) . \$1/gme; print \$log;" /tmp/logsamp 

adunstan

curl -H "Authorization: token $token" -s "https://api.github.com/orgs/$orgname/repos?per_page=100&page=$pagenum" | \
    jq -c -r '.[]|[.html_url, .private]'

adunstan

curl --header "Authorization: Bearer <your_access_token>" https://gitlab.example.com/api/v4/projects |
    jq -c -r '.[]|[.http_url_to_repo, .visibility]'

# works with private token or OAuth token

adunstan

ENV['VAGRANT_DEFAULT_PROVIDER'] = 'qemu'

# -*- mode: ruby -*-
# vi: set ft=ruby :

# All Vagrant configuration is done below. The "2" in Vagrant.configure
# configures the configuration version (we support older styles for
# backwards compatibility). Please don't change it unless you know what
# you're doing.

adunstan

This is Claude's description of the code:
=============================================================================================================================

This C function creates a PostgreSQL extension function called get_table_ddl that generates the CREATE TABLE DDL for a given table without using SPI. Here's what it does:

Key Features:

    Takes a table name as input (supports schema.table format)
    Returns the complete CREATE TABLE statement as text
    Handles column definitions with proper data types and type modifiers